﻿if exists (select * from dbo.sysobjects where name = 'sp_Contract_Insert')	drop procedure [dbo].[sp_Contract_Insert]Go CREATE PROCEDURE dbo.sp_Contract_Insert	@uID		int,	@Number		int,	@Type		int,	@StartDate		datetime,	@EndDate		datetime,	@Date		datetime,	@Detail		ntext,	@Status		nvarchar(50)AS	INSERT INTO [Contract]([uID], [Number], [Type], [StartDate], [EndDate], [Date], [Detail], [Status])	VALUES(@uID, @Number, @Type, @StartDate, @EndDate, @Date, @Detail, @Status)Go 